<?php
	require_once("../../db/dbclass.php");
	require_once("../../model/userinfo.php");
	require_once("../../utils/common.php");
	$myDb=&DbController::getInstance();
	$param="select * from yj_sensitivity_record where status='1'";
	$result=$myDb->exec_query($param);
	$result_array=array();
	$i=0;
	while ($row=mysqli_fetch_array($result,MYSQL_ASSOC)) {
		$param="select * from yj_tweets where tweets_id='".$row['tweets_id']."'";
		$result_param=$myDb->exec_query($param);
		while ($row_content=mysqli_fetch_array($result_param,MYSQL_ASSOC)) {
			$arrayName = array('tweets_id' => $row_content['tweets_id'],'tweets_content'=>$row_content['tweets_content'] );
			$result_array[$i++]=$arrayName;
		}
	}
	$arr=array(
		"result"=>$result_array
		);
	echo json_encode($arr);
?>